inherited StoreFrame: TStoreFrame
  Width = 712
  Height = 557
  Padding.Left = 25
  Padding.Top = 20
  Padding.Right = 25
  Padding.Bottom = 25
  ExplicitWidth = 712
  ExplicitHeight = 557
  object TopPanel: TPanel
    AlignWithMargins = True
    Left = 25
    Top = 20
    Width = 662
    Height = 53
    Margins.Left = 0
    Margins.Top = 0
    Margins.Right = 0
    Margins.Bottom = 15
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 0
    object RightPanel: TPanel
      Left = 264
      Top = 0
      Width = 398
      Height = 53
      Align = alRight
      BevelOuter = bvNone
      TabOrder = 0
      object Label1: TLabel
        Left = 219
        Top = 0
        Width = 46
        Height = 16
        Caption = 'Nimetus'
      end
      object Label16: TLabel
        Left = 0
        Top = 0
        Width = 52
        Height = 16
        Caption = 'Tingimus'
      end
      object Label17: TLabel
        Left = 110
        Top = 0
        Width = 55
        Height = 16
        Caption = 'M'#228'rks'#245'na'
      end
      object SearchBox: TEdit
        Left = 219
        Top = 20
        Width = 174
        Height = 24
        TabOrder = 0
        OnChange = FilterControlsChange
      end
      object CondCombo: TComboBox
        Left = 0
        Top = 20
        Width = 104
        Height = 24
        Style = csDropDownList
        ItemHeight = 16
        ItemIndex = 0
        TabOrder = 1
        Text = 'Aktiivsed'
        OnChange = FilterControlsChange
        Items.Strings = (
          'Aktiivsed'
          'Mitteaktiivsed'
          'Vaja juurde'
          'Otsas')
      end
      object CheckBox1: TCheckBox
        Left = 296
        Top = 1
        Width = 97
        Height = 17
        Caption = 'v'#245'i kirjeldus'
        TabOrder = 2
      end
      object KeywordCombo: TComboBox
        Left = 110
        Top = 20
        Width = 103
        Height = 24
        Style = csDropDownList
        ItemHeight = 16
        Sorted = True
        TabOrder = 3
        OnChange = FilterControlsChange
        Items.Strings = (
          ''
          'Aktiivsed'
          'Mitteaktiivsed'
          'Otsas'
          'Vaja juurde')
      end
    end
    object LeftPanel: TPanel
      Left = 0
      Top = 0
      Width = 264
      Height = 53
      Align = alClient
      BevelOuter = bvNone
      Padding.Right = 6
      Padding.Bottom = 7
      TabOrder = 1
      DesignSize = (
        264
        53)
      object Label15: TLabel
        Left = 0
        Top = 0
        Width = 95
        Height = 16
        Caption = 'Osakond / grupp'
      end
      object DeptGroupCombo: TComboBox
        Left = 0
        Top = 20
        Width = 258
        Height = 24
        Style = csDropDownList
        Anchors = [akLeft, akTop, akRight]
        ItemHeight = 16
        ItemIndex = 0
        TabOrder = 0
        Text = 'K'#245'ik kategooriad'
        OnChange = FilterControlsChange
        Items.Strings = (
          'K'#245'ik kategooriad')
      end
    end
  end
  object Grid: TDBGrid
    Left = 25
    Top = 88
    Width = 662
    Height = 252
    Align = alClient
    DataSource = Source
    Options = [dgEditing, dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -13
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'NIMETUS'
        Width = 200
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'YHIK'
        Width = 40
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'HIND'
        Width = 40
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'LAOSEIS'
        Title.Caption = 'Arvut. laoseis'
        Width = 45
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'TEGELIK_LAOSEIS'
        Width = 50
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'TELLIDA'
        Width = 45
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'OSAKOND'
        Width = 100
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'GRUPP'
        Width = 100
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'TYYP'
        Width = 35
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'AKTIIVNE'
        PickList.Strings = (
          '0'
          '1')
        Width = 50
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'KIIRKOOD'
        Width = 50
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'KM_PROTSENT'
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'MARKSONAD'
        Width = 100
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'YHIKU_KOGUS'
        Width = 40
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'KEHTIVUSAEG'
        Title.Caption = 'Kehtivus- aeg'
        Width = 55
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'KIRJELDUS'
        Width = 250
        Visible = True
      end>
  end
  object BottomPanel: TPanel
    AlignWithMargins = True
    Left = 25
    Top = 360
    Width = 662
    Height = 172
    Margins.Left = 0
    Margins.Top = 20
    Margins.Right = 0
    Margins.Bottom = 0
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 2
    object ChangesPanel: TPanel
      AlignWithMargins = True
      Left = 465
      Top = 0
      Width = 197
      Height = 172
      Margins.Left = 15
      Margins.Top = 0
      Margins.Right = 0
      Margins.Bottom = 0
      Align = alRight
      BevelOuter = bvNone
      TabOrder = 0
      object TitleLabel: TLabel
        Left = 1
        Top = 0
        Width = 85
        Height = 19
        Caption = 'Muudatused'
        Enabled = False
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -16
        Font.Name = 'Tahoma'
        Font.Style = []
        ParentFont = False
      end
      object Label2: TLabel
        Left = 0
        Top = 40
        Width = 115
        Height = 16
        Caption = 'Muudetud tooteid: 0'
        Enabled = False
      end
      object Label3: TLabel
        Left = 0
        Top = 72
        Width = 161
        Height = 16
        Caption = 'Vaja juurde tellida: 0 toodet'
        Enabled = False
      end
      object Label4: TLabel
        Left = 0
        Top = 104
        Width = 155
        Height = 16
        Caption = 'Laoseis muudetud: 0 tootel'
        Enabled = False
      end
      object SaveButton: TButton
        Left = 0
        Top = 144
        Width = 122
        Height = 25
        Caption = 'Salvesta'
        TabOrder = 0
        OnClick = SaveButtonClick
      end
      object CancelButton: TButton
        Left = 128
        Top = 144
        Width = 67
        Height = 25
        Caption = 'T'#252'hista'
        Enabled = False
        TabOrder = 1
      end
      object Button1: TButton
        Left = 112
        Top = 16
        Width = 75
        Height = 25
        Caption = 'Button1'
        TabOrder = 2
      end
    end
    object DetailPages: TPageControl
      Left = 0
      Top = 0
      Width = 450
      Height = 172
      ActivePage = TabSheet2
      Align = alClient
      TabOrder = 1
      object TabSheet1: TTabSheet
        Caption = 'Toote t'#228'psustus'
      end
      object TabSheet2: TTabSheet
        Caption = 'Statistika'
        ImageIndex = 1
      end
      object TabSheet4: TTabSheet
        Caption = 'Mitme toote muutmine'
        ImageIndex = 3
      end
    end
  end
  object LookupGrid: TDBGrid
    Left = 456
    Top = 164
    Width = 241
    Height = 137
    DataSource = LookupSource
    Options = [dgColumnResize, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
    TabOrder = 3
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -13
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'KIIRKOOD'
        Width = 50
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'NIMETUS'
        Visible = True
      end>
  end
  object Source: TDataSource
    DataSet = Ds
    Left = 448
    Top = 128
  end
  object Ds: TClientDataSet
    Active = True
    Aggregates = <>
    Params = <>
    ProviderName = 'Provider'
    OnFilterRecord = DsFilterRecord
    Left = 480
    Top = 128
    object DsID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object DsNIMETUS: TStringField
      DisplayLabel = 'Nimetus'
      FieldName = 'NIMETUS'
      Required = True
      Size = 100
    end
    object DsKIRJELDUS: TStringField
      DisplayLabel = 'Kirjeldus'
      FieldName = 'KIRJELDUS'
      Size = 250
    end
    object DsTYYP: TSmallintField
      DisplayLabel = 'T'#252#252'p'
      FieldName = 'TYYP'
    end
    object DsLAOSEIS: TBCDField
      DisplayLabel = 'Laoseis'
      FieldName = 'LAOSEIS'
      Precision = 9
      Size = 3
    end
    object DsHIND: TBCDField
      DisplayLabel = 'Hind'
      FieldName = 'HIND'
      Required = True
      Precision = 9
      Size = 2
    end
    object DsKM_PROTSENT: TBCDField
      DisplayLabel = 'KM %'
      FieldName = 'KM_PROTSENT'
      Precision = 9
      Size = 2
    end
    object DsOSAKOND: TStringField
      DisplayLabel = 'Osakond'
      FieldName = 'OSAKOND'
      Required = True
      Size = 50
    end
    object DsGRUPP: TStringField
      DisplayLabel = 'Grupp'
      FieldName = 'GRUPP'
      Required = True
      Size = 50
    end
    object DsKIIRKOOD: TStringField
      DisplayLabel = 'Kiirkood'
      FieldName = 'KIIRKOOD'
      Size = 5
    end
    object DsMARKSONAD: TStringField
      DisplayLabel = 'M'#228'rks'#245'nad'
      FieldName = 'MARKSONAD'
      Size = 100
    end
    object DsYHIKU_KOGUS: TBCDField
      DisplayLabel = #220'hiku kogus'
      FieldName = 'YHIKU_KOGUS'
      Precision = 9
      Size = 2
    end
    object DsKEHTIVUSAEG: TBCDField
      DisplayLabel = 'Kehtivusaeg'
      FieldName = 'KEHTIVUSAEG'
      Precision = 9
      Size = 2
    end
    object DsYHIK: TStringField
      DisplayLabel = #220'hik'
      FieldName = 'YHIK'
      Size = 10
    end
    object DsAKTIIVNE: TSmallintField
      DisplayLabel = 'Aktiivne'
      FieldName = 'AKTIIVNE'
      Required = True
    end
    object DsTARNIJA_ID: TIntegerField
      FieldName = 'TARNIJA_ID'
    end
    object DsTEGELIK_LAOSEIS: TBCDField
      DisplayLabel = 'Tegelik laoseis'
      FieldKind = fkInternalCalc
      FieldName = 'TEGELIK_LAOSEIS'
    end
    object DsTELLIDA: TBCDField
      DisplayLabel = 'Juurde tellida'
      FieldKind = fkInternalCalc
      FieldName = 'TELLIDA'
    end
  end
  object Provider: TDataSetProvider
    DataSet = Query
    Left = 512
    Top = 128
  end
  object Query: TSQLDataSet
    SchemaName = 'sysdba'
    GetMetadata = False
    CommandText = 
      'select'#13#10'id,'#13#10'nimetus,'#13#10'kirjeldus,'#13#10'tyyp,'#13#10'laoseis,'#13#10'hind,'#13#10'km_pr' +
      'otsent,'#13#10'osakond,'#13#10'grupp,'#13#10'kiirkood,'#13#10'marksonad,'#13#10'yhiku_kogus,'#13#10 +
      'kehtivusaeg,'#13#10'yhik,'#13#10'aktiivne,'#13#10'tarnija_id'#13#10'from TOOTED'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = ProgramModule.Connection
    Left = 544
    Top = 128
  end
  object LookupSource: TDataSource
    DataSet = LookupDs
    Left = 527
    Top = 256
  end
  object LookupDs: TClientDataSet
    Aggregates = <>
    Params = <>
    OnFilterRecord = LookupDsFilterRecord
    Left = 488
    Top = 256
    object LookupDsID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object LookupDsNIMETUS: TStringField
      FieldName = 'NIMETUS'
      Required = True
      Size = 100
    end
    object LookupDsKIRJELDUS: TStringField
      FieldName = 'KIRJELDUS'
      Size = 250
    end
    object LookupDsTYYP: TSmallintField
      FieldName = 'TYYP'
    end
    object LookupDsLAOSEIS: TBCDField
      FieldName = 'LAOSEIS'
      Precision = 9
      Size = 3
    end
    object LookupDsHIND: TBCDField
      FieldName = 'HIND'
      Required = True
      Precision = 9
      Size = 2
    end
    object LookupDsKM_PROTSENT: TBCDField
      FieldName = 'KM_PROTSENT'
      Precision = 9
      Size = 2
    end
    object LookupDsOSAKOND: TStringField
      FieldName = 'OSAKOND'
      Required = True
      Size = 50
    end
    object LookupDsGRUPP: TStringField
      FieldName = 'GRUPP'
      Required = True
      Size = 50
    end
    object LookupDsKIIRKOOD: TStringField
      FieldName = 'KIIRKOOD'
      Size = 5
    end
    object LookupDsMARKSONAD: TStringField
      FieldName = 'MARKSONAD'
      Size = 100
    end
    object LookupDsYHIKU_KOGUS: TBCDField
      FieldName = 'YHIKU_KOGUS'
      Precision = 9
      Size = 2
    end
    object LookupDsKEHTIVUSAEG: TBCDField
      FieldName = 'KEHTIVUSAEG'
      Precision = 9
      Size = 2
    end
    object LookupDsYHIK: TStringField
      FieldName = 'YHIK'
      Size = 10
    end
    object LookupDsAKTIIVNE: TSmallintField
      FieldName = 'AKTIIVNE'
      Required = True
    end
    object LookupDsTARNIJA_ID: TIntegerField
      FieldName = 'TARNIJA_ID'
    end
  end
end
